-- 2024年7月2日09:23:46
-- 新建表 [mh_range]
USE [ry-vue]
GO

/****** Object:  Table [dbo].[mh_range]    Script Date: 2024/7/1 15:04:13 ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

CREATE TABLE [dbo].[mh_range](
    [zd_min] [float] NULL,
    [zd_max] [float] NULL,
    [yq_gz] [float] NULL,
    [yq_gl] [float] NULL,
    [eq_gz] [float] NULL
) ON [PRIMARY]
    GO

-- 2024年7月2日09:23:53
-- 删除字段 front_term 的 target_zd_term

-- 2024年7月2日12:07:15
-- ai_config 添加字段 end_date 并修改start_date字段类型
-- tjl_result 修改字段类型start_date 从int修改为varchar

-- 2024年7月19日09:10:27
    表[ai_config]
添加两个字段    [reference_type_gz]
    ,[reference_type_gl]
删除一个字段reference_type

-- 2024年7月22日08:51:03
    USE [ry-vue]
    GO

/****** Object:  Table [dbo].[arm_front_term]    Script Date: 2024/7/22 8:58:39 ******/
    新建表 arm_front_term
    SET ANSI_NULLS ON
    GO

    SET QUOTED_IDENTIFIER ON
    GO

CREATE TABLE [dbo].[arm_front_term](
    [id] [int] NOT NULL,
    [yq_jsll_term] [float] NULL,
    [yq_jsll_term_show] [bit] NULL,
    [fit102_term] [float] NULL,
    [fit102_term_show] [bit] NULL,
    [jnyszd_term] [float] NULL,
    [jnyszd_term_show] [bit] NULL,
    [jnysph_term] [float] NULL,
    [jnysph_term_show] [bit] NULL,
    [mit101_t_term] [float] NULL,
    [mit101_t_term_show] [bit] NULL,
    [ait101_ph_term] [float] NULL,
    [ait101_ph_term_show] [bit] NULL,
    [ait101_t_term] [float] NULL,
    [ait101_t_term_show] [bit] NULL,
    [target_zd_yq_term] [float] NULL,
    [target_zd_yq_term_show] [bit] NULL,
    [target_zd_eq_term] [float] NULL,
    [target_zd_eq_term_show] [bit] NULL,
    [shsjtjll4_term] [float] NULL,
    [shsjtjll4_term_show] [bit] NULL,
    [shsjtjll2_term] [float] NULL,
    [shsjtjll2_term_show] [bit] NULL
) ON [PRIMARY]
    GO

-- 2024年7月23日09:02:50
更新表  front_term
    SET ANSI_NULLS ON
    GO

    SET QUOTED_IDENTIFIER ON
    GO

CREATE TABLE [dbo].[front_term](
    [id] [int] NOT NULL,
    [yq_jsll_term] [float] NULL,
    [yq_jsll_term_show] [bit] NULL,
    [fit102_term] [float] NULL,
    [fit102_term_show] [bit] NULL,
    [jnyszd_term] [float] NULL,
    [jnyszd_term_show] [bit] NULL,
    [jnysph_term] [float] NULL,
    [jnysph_term_show] [bit] NULL,
    [mit101_t_term] [float] NULL,
    [mit101_t_term_show] [bit] NULL,
    [ait101_ph_term] [float] NULL,
    [ait101_ph_term_show] [bit] NULL,
    [ait101_t_term] [float] NULL,
    [ait101_t_term_show] [bit] NULL,
    [target_zd_yq_term] [float] NULL,
    [target_zd_yq_term_show] [bit] NULL,
    [target_zd_eq_term] [float] NULL,
    [target_zd_eq_term_show] [bit] NULL,
    [shsjtjll4_term] [float] NULL,
    [shsjtjll4_term_show] [bit] NULL,
    [shsjtjll2_term] [float] NULL,
    [shsjtjll2_term_show] [bit] NULL
) ON [PRIMARY]
    GO

-- 2024年7月23日09:37:24
ai_config 添加字段 month_space